<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>WIKINDX CLASS DOCUMENTATION</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="/wikindx2/docs/docs.css" type="text/css" />
</head>

<body bgcolor="#FFFFFF" text="#000000">
<h2>WIKINDX METHODS</h2>
<p><strong>Method:</strong><br />
  
  select()
</p>
<p><strong>Class:</strong><br />

  <a href="sqlClass.html">SQL</a>
<p><strong>Method Call:</strong><br />
  include_once("core/sql/SQL.php");<br />
$db = new SQL();<br />
ADODB_RECORDSET $db->select(ARRAY: $tables, ARRAY: $fields, [STRING: $condition]); </p>
<p><strong>Description:</strong><br />
  
Execute a SELECT statement.  If $fields contains an associative array (or arrays), then that inner array is treated as an alias and is 
parsed by <a href="formataliasMethod.html">formatAlias()</a>.</p>
<p>Do not add backticks, single-quotes etc. - the SQL class will do this automatically depending on the database we're 
    connected to as long as $fields is an ARRAY.</p>
<p>The return is an ADODB_RECORDSET suitable for passing to the <a href="fetchRowMethod.html">fetchRow()</a>, <a href="loopRecordSetMethod.html">loopRecordSet()</a> or <a href="fetchOneMethod.html">fetchOne()</a> methods etc. If it fails to execute the query, the script will exit with an error message. </p>
<p><strong>Usage:</strong><br />
For example (assuming the database object exists within a class as $this->db):</p>
<pre>
	$tables = array("WKX_resource");
	$fields = array(array("WKX_resource.title" => "t"), "subtitle");
	$condition = "WHERE " . $this->db->formatField('id')  . "=" . $this->db->tidyInput(666);
	$recordset = $this->db->select($tables, $fields, $condition);</pre>	

In the above example the SELECT statement as formatted by select() before internally passing to <a href="queryMethod.html">query()</a> will be:
<pre>
	SELECT `WKX_resource`.`title` AS `t`, `subtitle` FROM `WKX_resource` WHERE `id`='666';
</pre>

<p align="right"><a href="../../index.html">WIKINDX home</a>
&nbsp;&nbsp;&nbsp;&nbsp;
<a href="../../usage/index.html">WIKINDX usage</a>
&nbsp;&nbsp;&nbsp;&nbsp;
<a href="../index.html">WIKINDX classes</a>
</p>
</body>

</html>
